SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweLicenciasHistoricascert
AS
SELECT     idLicenciaHistoricaOLD AS ID, Agente, OrganizacionHistorica, FechaAlta, Baja, FechaBaja, Funcion, Modalidad, Zona, Categoria, cargo, 
                      FrenteAlumno
FROM         dbo.tb_LicenciasHistoricasCert
GO
GRANT SELECT ON  [dbo].[vweLicenciasHistoricascert] TO [CertificacionesServicios]
GRANT INSERT ON  [dbo].[vweLicenciasHistoricascert] TO [CertificacionesServicios]
GRANT DELETE ON  [dbo].[vweLicenciasHistoricascert] TO [CertificacionesServicios]
GRANT UPDATE ON  [dbo].[vweLicenciasHistoricascert] TO [CertificacionesServicios]
GRANT SELECT ON  [dbo].[vweLicenciasHistoricascert] TO [SoloVer]
GO
